
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE ID = OBJECT_ID(N'Setting') and OBJECTPROPERTY(ID, N'IsUserTable') = 1) BEGIN

   -- Create Employee 1:N table
   CREATE TABLE [Setting] (
   	[Id] INT IDENTITY (1, 1) NOT NULL ,
   	[ShopNamePrefix]	NVARCHAR(255),
   	[ShopName]			NVARCHAR(255),
   	[ShopAddress]		NVARCHAR(255),
   	[ShopPhoneNumber]	NVARCHAR(255),
   	[ActivationCode]	NVARCHAR(255)
   
      -- Create non-clustered primary key
   	CONSTRAINT [rpk_Setting] PRIMARY KEY NONCLUSTERED 
   	(
   		[Id]
   	)  ON [PRIMARY] ,
   ) ON [PRIMARY]

END








